Server Triggers

A server trigger can be a DDL or logon trigger for current server. DDL triggers execute in response to a variety of data definition language (DDL) events. These events primarily correspond to Transact-SQL CREATE, ALTER, and DROP statements, and certain system stored procedures that perform DDL-like operations. Logon triggers fire in response to the LOGON event that is raised when a user sessions is being established.

Note: Support from SQL Server 2005 or later.

Just simply click -> Server Trigger to open an object pane for Server Trigger. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit and delete the selected server trigger.

Create Server Trigger

To create a new server trigger

To create a new server trigger with modification as one of the existing server trigger

Edit Server Trigger

To edit the existing server trigger(manage its general etc)

Maintain Server Trigger

To maintain a server trigger

Delete Server Trigger

To delete a server trigger

Achieve Server Trigger Information

To achieve a server trigger information